---
title: getHeader stored procedure documentation
summary: Oracle package member pk80001_legalnet.getHeader — not present in retrieved package artifact.
status: draft
owner: SAIF Documentation Generator
last_reviewed: 2026-08-31
source_schema: WCIS_DBA
source_name: pk80001_legalnet.getHeader
source_type: PROCEDURE
retrieval_status: not-found-by-cli
retrieval_command: legends oracle query --name pk80001_legalnet
retrieval_date: 2026-08-31
---

# getHeader

> [!WARNING]
> **Status: `not-found-by-cli`.** The package `WCIS_DBA.pk80001_legalnet` was retrieved successfully in full (spec + body, 98 enumerated members, 148,911 characters) via `legends oracle query --name pk80001_legalnet` on 2026-08-31. A case-insensitive search of the entire retrieved source for the substring `header` returns **zero matches** — `getHeader` is not a member of the retrieved package. The .NET call site `SAIF.Application.Claim.Legal/clsLegalData.vb:31` (`Return "pk80001_legalNet.getHeader"`) is a live, verified binding: `clsLegalData` is constructed and consumed as a read-only value object, and if this code path executes against an environment whose `pk80001_legalnet` matches the retrieved version, the call would fail at runtime with `ORA-06550`/`PLS-00302` (undefined program unit). This is most likely environment/version drift or a removed package member, not evidence that `clsLegalData` is dead code — treat the caller as a live call site that would error if invoked, not as unreachable code. Do not present a fabricated signature for `getHeader`.

## Overview

| Field | Value |
| --- | --- |
| **Schema** | `WCIS_DBA` |
| **Package** | `pk80001_legalnet` |
| **Type** | PROCEDURE (inferred from caller) |
| **Database** | Oracle |
| **Status** | ⚠️ Member not found in retrieved package; package itself was successfully retrieved |
| **Query executed** | `legends oracle query --name pk80001_legalnet` (2026-08-31T21:20:00Z) |
| **Calling libraries** | `SAIF.Application.Claim.Legal` |
| **Calling classes** | `clsLegalData` |

## Call Sites

The .NET caller references this procedure as a stored procedure invocation:

| Class | Method | Source File | Evidence |
| --- | --- | --- | --- |
| `clsLegalData` | `.New(IDataPortalInfo, ClaimID, LegalCaseSeqNum)` constructor | `SAIF.Application.Claim.Legal\clsLegalData.vb:29–31` | `Return "pk80001_legalNet.getHeader"` via `RetrieveSQL` read-only property |

### Caller-side invocation detail

Source: `SAIF.Application.Claim.Legal\clsLegalData.vb:29–65`

```vbnet
Friend ReadOnly Property RetrieveSQL() As String
    Get
        Return "pk80001_legalNet.getHeader"
    End Get
End Property

' clsLegalData constructor
Public Sub New(ByVal inDPI As IDataPortalInfo, ByVal inClaimId As Decimal, ByVal inLegalCaseSeqNum As Decimal)
    Dim result = SqlHelper.ResultSetQuery(inDPI, "Get Legal Information")
    ' Parameter binding (inferred from .NET code):
    ' Command: CommandType.StoredProcedure; Name: "pk80001_legalNet.getHeader"
    ' Parameters:
    '   AddParm("aLegalCaseNum", inLegalCaseSeqNum) — IN NUMBER
    '   AddCursorParm("recordset") — OUT REF CURSOR
    ' Result set consumed:
    If result.Any Then
        m_CaseNum = result.First.GetString("CaseNum")
        m_AttyName = result.First.GetString("AttyName")
        m_CaseStatus = result.First.GetString("CaseStatus")
        m_HearingDate = CDate(result.First.GetString("HearingDate"))
    End If
End Sub
```

## Inferred Signature

> **These parameters are inferred from the caller only.** The procedure body is not available; this signature describes only what `clsLegalData.vb` binds. No actual PL/SQL signature has been extracted.

| Parameter | Direction (inferred) | Type (inferred) | Description |
| --- | --- | --- | --- |
| `aLegalCaseNum` | IN | NUMBER | Legal case sequence number passed as `inLegalCaseSeqNum` from the constructor. |
| `recordset` | OUT | REF CURSOR | Result set cursor expected by `SqlHelper.ResultSetQuery`. |

### Result-set columns consumed by caller

| Column | .NET accessor | Mapped property | Type |
| --- | --- | --- | --- |
| `CaseNum` | `GetString` | `clsLegalData.CaseNum` | String |
| `AttyName` | `GetString` | `clsLegalData.AttorneyName` | String |
| `CaseStatus` | `GetString` | `clsLegalData.CaseStatus` | String |
| `HearingDate` | `GetString` then `CDate` | `clsLegalData.HearingDate` | Date (via CDate conversion) |

## Cross-library corroboration

The same package `WCIS_DBA.pk80001_legalnet` is referenced by `SAIF.Business.Claim.Legal` in its `saif-business-claim-legal/procedures/pk80001_legalnet.md`. That library's documentation does **not** include a `getHeader` entry despite cataloging all 98 retrieved members — an independent confirmation that the member is genuinely absent from the retrieved artifact.

## Related Documentation
- [Procedure catalog](index.md)

## Sources
- Legends CLI query executed 2026-08-31T21:20:00Z: `legends oracle query --name pk80001_legalnet` — retrieved `WCIS_DBA.pk80001_legalnet` spec + body (148,911 characters, 98 enumerated members); substring search for "header" across full source returned 0 matches
- Referencing code: `SAIF.Application.Claim.Legal\clsLegalData.vb:29–65` (caller-side inference only; no procedure body available)
- Cross-library verification: `SAIF.Business.Claim.Legal\procedures\pk80001_legalnet.md` (same package, no `getHeader` member documented)